<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SQLAccountDetail.aspx.cs" Inherits="SQLAccountDetail" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table id="Table3" cellpadding="5" cellspacing="0"  width="100%">
        <tr>
            <td bgcolor="#EBE7E7" colspan="2">SQL Account Detail
                    <span style="font-size: 8pt">(SQL Server 2005 Logins only)</span></span></td>
        </tr>
        </table>
        <table id="tblMain" cellpadding="0" cellspacing="1"  width="100%">
        <tr style="color: #000000">
            <td colspan="2" style="text-align: left;">
                <table id="TABLE1" cellpadding="3" cellspacing="0" width="100%">
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px">
                            Instance Name:</td>
                        <td style="text-align: left">
                            <asp:Label ID="txtInstanceName" runat="server" Font-Bold="True"></asp:Label></td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px">
                            SQL Login:</td>
                        <td style="text-align: left">
                            <asp:Label ID="txtLoginName" runat="server" Font-Bold="True"></asp:Label></td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px;" valign=top>
                            Is Expired:</td>
                        <td style="text-align: left;">
                            <asp:Label ID="txtIsExpired" runat="server"></asp:Label><br />
                            <table id="tblIsExpired" width="100%" runat=server>
                                <tr>
                                    <td bgcolor="black" colspan="2" style="width: 293px">
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="2" style="text-align: center">
                                        <br />
                                        <asp:Button ID="btnUnExpireAccount" runat="server" Text="Un-Expire Account" OnClick="btnUnExpireAccount_Click"/>
                                        <br />
                                        <br />
                                        <asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl="http://msdn2.microsoft.com/en-us/library/ms161959.aspx"
                                            Target="_blank" Width="241px">Password Policy (MSDN)</asp:HyperLink></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px;" valign=top>
                            Is Locked:</td>
                        <td style="text-align: left;">
                            <asp:Label ID="txtIsLocked" runat="server" Text=""></asp:Label><br />
                            <table id="tblPasswordIsLocked" width="100%" runat=server>
                                <tr>
                                    <td bgcolor="black" colspan="2" style="width: 293px">
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="2" style="width: 293px">
                            <asp:RadioButtonList ID="rdoUnlockType" runat="server" OnSelectedIndexChanged="rdoUnlockType_SelectedIndexChanged" AutoPostBack="True" Width="446px" >
                                <asp:ListItem Value="0" Selected="True">Un-Lock (Keep Existing Password)</asp:ListItem>
                                <asp:ListItem Value="1">Un-Lock* (With New Password)</asp:ListItem>
                                <asp:ListItem Value="2">Un-Lock* (Force Change Password On Next Login)</asp:ListItem>
                            </asp:RadioButtonList></td>
                                </tr>
                                <tr>
                                    <td>
                                        &nbsp;<asp:Label ID="lblNewPassword" runat="server" Text="New Password:" Visible="False"></asp:Label></td>
                                    <td><asp:TextBox ID="txtNewPassword" runat="server" Visible="False" Width="198px"></asp:TextBox><asp:RequiredFieldValidator ID="validatorNewPasswordRequired" runat="server" ControlToValidate="txtNewPassword"
                                            Display="Dynamic" ErrorMessage="Required" Font-Bold="True" Font-Size="X-Small"></asp:RequiredFieldValidator></td>
                                </tr>
                                <tr>
                                    <td>
                                        &nbsp;<asp:Label ID="lblEMailAddress" runat="server" Text="EMail Address:"></asp:Label></td>
                                    <td><asp:TextBox ID="txtEMailAddress" runat="server" Width="288px"></asp:TextBox><asp:RequiredFieldValidator ID="ValidatorEMailRequired" runat="server" ControlToValidate="txtEMailAddress"
                                            Display="Dynamic" ErrorMessage="Required" Font-Bold="True" Font-Size="X-Small"></asp:RequiredFieldValidator><asp:RegularExpressionValidator
                                                ID="ValidatorEMailInvalid" runat="server" ControlToValidate="txtEMailAddress"
                                                Display="Dynamic" ErrorMessage="Invalid" Font-Bold="True" Font-Size="X-Small"
                                                ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
                                                                        </td>
                                </tr>
                                <tr>
                                    <td valign=top>
                                        &nbsp;<asp:Label ID="lblComment" runat="server" Text="Comments:"></asp:Label></td>
                                    <td>
                                        <asp:TextBox ID="txtComments" runat="server" Height="51px" TextMode="MultiLine" Width="381px"></asp:TextBox></td>
                                </tr>
                                <tr>
                                    <td bgcolor="black" colspan="2" style="width: 193px">
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="2">
                                        <asp:CheckBox ID="chkEnforcePasswordPolicy" runat="server" Text="Enforce Password Policy" AutoPostBack="True" Width="220px" OnCheckedChanged="chkEnforcePasswordPolicy_CheckedChanged" Checked="True" />
                                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="http://msdn2.microsoft.com/en-us/library/ms161959.aspx"
                                            Target="_blank" Width="241px">Password Policy (MSDN)</asp:HyperLink></td>
                                </tr>
                                <tr>
                                    <td colspan="2" style="width: 122px">
                                        <asp:CheckBox ID="chkEnforcePasswordExiration" runat="server" Text="Enforce Password Expiration (Usually NOT CHECKED)"
                                            Width="398px" />&nbsp;</td>
                                </tr>
                                <tr>
                                    <td bgcolor="black" colspan="2" style="width: 122px; text-align: left;">
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="2" style="text-align: center">
                                        <br />
                                        <asp:Button ID="btnUnlockLogin" runat="server" Text="Un-Lock Account" OnClick="btnUnlockLogin_Click" /><br />
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px">
                            Lockout Time:                       Lockout Time:</td>
                        <td colspan="1" style="text-align: left">
                            <asp:Label ID="txtLockoutTime" runat="server" Text=""></asp:Label></td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px">
                            Is Policy Checked:</td>
                        <td colspan="1" style="text-align: left">
                            <asp:Label ID="txtIsPolicyChecked" runat="server" Text=""></asp:Label></td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px">
                            Is Expiration Checked:</td>
                        <td colspan="1" style="text-align: left">
                            <asp:Label ID="txtIsExpirationChecked" runat="server" Text=""></asp:Label></td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px;">
                            Default Database:</td>
                        <td colspan="1">
                            <asp:Label ID="txtDefaultDatabase" runat="server" Text=""></asp:Label></td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px">
                            Create Date:</td>
                        <td colspan="1" style="text-align: left">
                            <asp:Label ID="txtCreateDate" runat="server" Text=""></asp:Label></td>
                    </tr>
                    <tr>
                        <td bgcolor="#EBE7E7" style="width: 215px;">
                            Modify Date:</td>
                        <td colspan="1">
                            <asp:Label ID="txtModifyDate" runat="server" Text=""></asp:Label></td>
                    </tr>
                </table>
                <span style="font-size: 8pt"><strong>
                    <br />
                    &nbsp; *NOTE:&nbsp; </strong>Unlocking a SQL Account with password change may affect Failover
                    and Business Recovery Access.</span></td>
        </tr>
    </table>
</asp:Content>

